

if exists(select name from sysobjects where name = 'sp_TuanGetTuanHienTai')
	drop proc sp_TuanGetTuanHienTai
go
/*
	Created by: Phuoc NH
	Created on: 5/12/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_TuanGetTuanHienTai.sql
*/

create proc sp_TuanGetTuanHienTai
as
begin
	select Tuan from Tuan where GETDATE()>=NgayDau and GETDATE()<=NgayCuoi
	
end

